package com.crm.model.entity.orderManager;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomerProductOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerProductOrderExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProductOrderIdIsNull() {
            addCriterion("product_order_id is null");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdIsNotNull() {
            addCriterion("product_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdEqualTo(String value) {
            addCriterion("product_order_id =", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdNotEqualTo(String value) {
            addCriterion("product_order_id <>", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdGreaterThan(String value) {
            addCriterion("product_order_id >", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("product_order_id >=", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdLessThan(String value) {
            addCriterion("product_order_id <", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdLessThanOrEqualTo(String value) {
            addCriterion("product_order_id <=", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdLike(String value) {
            addCriterion("product_order_id like", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdNotLike(String value) {
            addCriterion("product_order_id not like", value, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdIn(List<String> values) {
            addCriterion("product_order_id in", values, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdNotIn(List<String> values) {
            addCriterion("product_order_id not in", values, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdBetween(String value1, String value2) {
            addCriterion("product_order_id between", value1, value2, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andProductOrderIdNotBetween(String value1, String value2) {
            addCriterion("product_order_id not between", value1, value2, "productOrderId");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNull() {
            addCriterion("order_number is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNotNull() {
            addCriterion("order_number is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualTo(String value) {
            addCriterion("order_number =", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualTo(String value) {
            addCriterion("order_number <>", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThan(String value) {
            addCriterion("order_number >", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("order_number >=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThan(String value) {
            addCriterion("order_number <", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("order_number <=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLike(String value) {
            addCriterion("order_number like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotLike(String value) {
            addCriterion("order_number not like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIn(List<String> values) {
            addCriterion("order_number in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotIn(List<String> values) {
            addCriterion("order_number not in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberBetween(String value1, String value2) {
            addCriterion("order_number between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotBetween(String value1, String value2) {
            addCriterion("order_number not between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(String value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(String value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(String value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(String value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLike(String value) {
            addCriterion("order_status like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotLike(String value) {
            addCriterion("order_status not like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<String> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<String> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(String value1, String value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(String value1, String value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayIsNull() {
            addCriterion("order_payment_way is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayIsNotNull() {
            addCriterion("order_payment_way is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayEqualTo(String value) {
            addCriterion("order_payment_way =", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayNotEqualTo(String value) {
            addCriterion("order_payment_way <>", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayGreaterThan(String value) {
            addCriterion("order_payment_way >", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayGreaterThanOrEqualTo(String value) {
            addCriterion("order_payment_way >=", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayLessThan(String value) {
            addCriterion("order_payment_way <", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayLessThanOrEqualTo(String value) {
            addCriterion("order_payment_way <=", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayLike(String value) {
            addCriterion("order_payment_way like", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayNotLike(String value) {
            addCriterion("order_payment_way not like", value, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayIn(List<String> values) {
            addCriterion("order_payment_way in", values, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayNotIn(List<String> values) {
            addCriterion("order_payment_way not in", values, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayBetween(String value1, String value2) {
            addCriterion("order_payment_way between", value1, value2, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andOrderPaymentWayNotBetween(String value1, String value2) {
            addCriterion("order_payment_way not between", value1, value2, "orderPaymentWay");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNull() {
            addCriterion("contract_type is null");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNotNull() {
            addCriterion("contract_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractTypeEqualTo(String value) {
            addCriterion("contract_type =", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotEqualTo(String value) {
            addCriterion("contract_type <>", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThan(String value) {
            addCriterion("contract_type >", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_type >=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThan(String value) {
            addCriterion("contract_type <", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_type <=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLike(String value) {
            addCriterion("contract_type like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotLike(String value) {
            addCriterion("contract_type not like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeIn(List<String> values) {
            addCriterion("contract_type in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotIn(List<String> values) {
            addCriterion("contract_type not in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeBetween(String value1, String value2) {
            addCriterion("contract_type between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotBetween(String value1, String value2) {
            addCriterion("contract_type not between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountIsNull() {
            addCriterion("order_discount_total_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountIsNotNull() {
            addCriterion("order_discount_total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountEqualTo(BigDecimal value) {
            addCriterion("order_discount_total_amount =", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_discount_total_amount <>", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountGreaterThan(BigDecimal value) {
            addCriterion("order_discount_total_amount >", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_discount_total_amount >=", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountLessThan(BigDecimal value) {
            addCriterion("order_discount_total_amount <", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_discount_total_amount <=", value, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountIn(List<BigDecimal> values) {
            addCriterion("order_discount_total_amount in", values, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_discount_total_amount not in", values, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_discount_total_amount between", value1, value2, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountTotalAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_discount_total_amount not between", value1, value2, "orderDiscountTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountIsNull() {
            addCriterion("order_actual_total_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountIsNotNull() {
            addCriterion("order_actual_total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountEqualTo(BigDecimal value) {
            addCriterion("order_actual_total_amount =", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_actual_total_amount <>", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountGreaterThan(BigDecimal value) {
            addCriterion("order_actual_total_amount >", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_actual_total_amount >=", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountLessThan(BigDecimal value) {
            addCriterion("order_actual_total_amount <", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_actual_total_amount <=", value, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountIn(List<BigDecimal> values) {
            addCriterion("order_actual_total_amount in", values, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_actual_total_amount not in", values, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_actual_total_amount between", value1, value2, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderActualTotalAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_actual_total_amount not between", value1, value2, "orderActualTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountIsNull() {
            addCriterion("order_total_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountIsNotNull() {
            addCriterion("order_total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountEqualTo(BigDecimal value) {
            addCriterion("order_total_amount =", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_total_amount <>", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountGreaterThan(BigDecimal value) {
            addCriterion("order_total_amount >", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_total_amount >=", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountLessThan(BigDecimal value) {
            addCriterion("order_total_amount <", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_total_amount <=", value, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountIn(List<BigDecimal> values) {
            addCriterion("order_total_amount in", values, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_total_amount not in", values, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_total_amount between", value1, value2, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTotalAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_total_amount not between", value1, value2, "orderTotalAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountIsNull() {
            addCriterion("paid_back_amount is null");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountIsNotNull() {
            addCriterion("paid_back_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountEqualTo(BigDecimal value) {
            addCriterion("paid_back_amount =", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountNotEqualTo(BigDecimal value) {
            addCriterion("paid_back_amount <>", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountGreaterThan(BigDecimal value) {
            addCriterion("paid_back_amount >", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_back_amount >=", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountLessThan(BigDecimal value) {
            addCriterion("paid_back_amount <", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_back_amount <=", value, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountIn(List<BigDecimal> values) {
            addCriterion("paid_back_amount in", values, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountNotIn(List<BigDecimal> values) {
            addCriterion("paid_back_amount not in", values, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_back_amount between", value1, value2, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andPaidBackAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_back_amount not between", value1, value2, "paidBackAmount");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeIsNull() {
            addCriterion("order_surcharge is null");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeIsNotNull() {
            addCriterion("order_surcharge is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeEqualTo(BigDecimal value) {
            addCriterion("order_surcharge =", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeNotEqualTo(BigDecimal value) {
            addCriterion("order_surcharge <>", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeGreaterThan(BigDecimal value) {
            addCriterion("order_surcharge >", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_surcharge >=", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeLessThan(BigDecimal value) {
            addCriterion("order_surcharge <", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_surcharge <=", value, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeIn(List<BigDecimal> values) {
            addCriterion("order_surcharge in", values, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeNotIn(List<BigDecimal> values) {
            addCriterion("order_surcharge not in", values, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_surcharge between", value1, value2, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_surcharge not between", value1, value2, "orderSurcharge");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusIsNull() {
            addCriterion("surcharge_status is null");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusIsNotNull() {
            addCriterion("surcharge_status is not null");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusEqualTo(String value) {
            addCriterion("surcharge_status =", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusNotEqualTo(String value) {
            addCriterion("surcharge_status <>", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusGreaterThan(String value) {
            addCriterion("surcharge_status >", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusGreaterThanOrEqualTo(String value) {
            addCriterion("surcharge_status >=", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusLessThan(String value) {
            addCriterion("surcharge_status <", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusLessThanOrEqualTo(String value) {
            addCriterion("surcharge_status <=", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusLike(String value) {
            addCriterion("surcharge_status like", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusNotLike(String value) {
            addCriterion("surcharge_status not like", value, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusIn(List<String> values) {
            addCriterion("surcharge_status in", values, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusNotIn(List<String> values) {
            addCriterion("surcharge_status not in", values, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusBetween(String value1, String value2) {
            addCriterion("surcharge_status between", value1, value2, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andSurchargeStatusNotBetween(String value1, String value2) {
            addCriterion("surcharge_status not between", value1, value2, "surchargeStatus");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkIsNull() {
            addCriterion("order_surcharge_remark is null");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkIsNotNull() {
            addCriterion("order_surcharge_remark is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkEqualTo(String value) {
            addCriterion("order_surcharge_remark =", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkNotEqualTo(String value) {
            addCriterion("order_surcharge_remark <>", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkGreaterThan(String value) {
            addCriterion("order_surcharge_remark >", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("order_surcharge_remark >=", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkLessThan(String value) {
            addCriterion("order_surcharge_remark <", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkLessThanOrEqualTo(String value) {
            addCriterion("order_surcharge_remark <=", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkLike(String value) {
            addCriterion("order_surcharge_remark like", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkNotLike(String value) {
            addCriterion("order_surcharge_remark not like", value, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkIn(List<String> values) {
            addCriterion("order_surcharge_remark in", values, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkNotIn(List<String> values) {
            addCriterion("order_surcharge_remark not in", values, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkBetween(String value1, String value2) {
            addCriterion("order_surcharge_remark between", value1, value2, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andOrderSurchargeRemarkNotBetween(String value1, String value2) {
            addCriterion("order_surcharge_remark not between", value1, value2, "orderSurchargeRemark");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNull() {
            addCriterion("contact_person is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNotNull() {
            addCriterion("contact_person is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonEqualTo(String value) {
            addCriterion("contact_person =", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotEqualTo(String value) {
            addCriterion("contact_person <>", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThan(String value) {
            addCriterion("contact_person >", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("contact_person >=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThan(String value) {
            addCriterion("contact_person <", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThanOrEqualTo(String value) {
            addCriterion("contact_person <=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLike(String value) {
            addCriterion("contact_person like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotLike(String value) {
            addCriterion("contact_person not like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonIn(List<String> values) {
            addCriterion("contact_person in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotIn(List<String> values) {
            addCriterion("contact_person not in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonBetween(String value1, String value2) {
            addCriterion("contact_person between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotBetween(String value1, String value2) {
            addCriterion("contact_person not between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberIsNull() {
            addCriterion("bind_mobile_phone_number is null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberIsNotNull() {
            addCriterion("bind_mobile_phone_number is not null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberEqualTo(String value) {
            addCriterion("bind_mobile_phone_number =", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberNotEqualTo(String value) {
            addCriterion("bind_mobile_phone_number <>", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberGreaterThan(String value) {
            addCriterion("bind_mobile_phone_number >", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberGreaterThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_number >=", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberLessThan(String value) {
            addCriterion("bind_mobile_phone_number <", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberLessThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_number <=", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberLike(String value) {
            addCriterion("bind_mobile_phone_number like", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberNotLike(String value) {
            addCriterion("bind_mobile_phone_number not like", value, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberIn(List<String> values) {
            addCriterion("bind_mobile_phone_number in", values, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberNotIn(List<String> values) {
            addCriterion("bind_mobile_phone_number not in", values, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_number between", value1, value2, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumberNotBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_number not between", value1, value2, "bindMobilePhoneNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailIsNull() {
            addCriterion("customer_email is null");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailIsNotNull() {
            addCriterion("customer_email is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailEqualTo(String value) {
            addCriterion("customer_email =", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailNotEqualTo(String value) {
            addCriterion("customer_email <>", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailGreaterThan(String value) {
            addCriterion("customer_email >", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailGreaterThanOrEqualTo(String value) {
            addCriterion("customer_email >=", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailLessThan(String value) {
            addCriterion("customer_email <", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailLessThanOrEqualTo(String value) {
            addCriterion("customer_email <=", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailLike(String value) {
            addCriterion("customer_email like", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailNotLike(String value) {
            addCriterion("customer_email not like", value, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailIn(List<String> values) {
            addCriterion("customer_email in", values, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailNotIn(List<String> values) {
            addCriterion("customer_email not in", values, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailBetween(String value1, String value2) {
            addCriterion("customer_email between", value1, value2, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andCustomerEmailNotBetween(String value1, String value2) {
            addCriterion("customer_email not between", value1, value2, "customerEmail");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentIsNull() {
            addCriterion("whether_co_development is null");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentIsNotNull() {
            addCriterion("whether_co_development is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentEqualTo(String value) {
            addCriterion("whether_co_development =", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentNotEqualTo(String value) {
            addCriterion("whether_co_development <>", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentGreaterThan(String value) {
            addCriterion("whether_co_development >", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentGreaterThanOrEqualTo(String value) {
            addCriterion("whether_co_development >=", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentLessThan(String value) {
            addCriterion("whether_co_development <", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentLessThanOrEqualTo(String value) {
            addCriterion("whether_co_development <=", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentLike(String value) {
            addCriterion("whether_co_development like", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentNotLike(String value) {
            addCriterion("whether_co_development not like", value, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentIn(List<String> values) {
            addCriterion("whether_co_development in", values, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentNotIn(List<String> values) {
            addCriterion("whether_co_development not in", values, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentBetween(String value1, String value2) {
            addCriterion("whether_co_development between", value1, value2, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherCoDevelopmentNotBetween(String value1, String value2) {
            addCriterion("whether_co_development not between", value1, value2, "whetherCoDevelopment");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendIsNull() {
            addCriterion("whether_suspend is null");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendIsNotNull() {
            addCriterion("whether_suspend is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendEqualTo(String value) {
            addCriterion("whether_suspend =", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendNotEqualTo(String value) {
            addCriterion("whether_suspend <>", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendGreaterThan(String value) {
            addCriterion("whether_suspend >", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendGreaterThanOrEqualTo(String value) {
            addCriterion("whether_suspend >=", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendLessThan(String value) {
            addCriterion("whether_suspend <", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendLessThanOrEqualTo(String value) {
            addCriterion("whether_suspend <=", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendLike(String value) {
            addCriterion("whether_suspend like", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendNotLike(String value) {
            addCriterion("whether_suspend not like", value, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendIn(List<String> values) {
            addCriterion("whether_suspend in", values, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendNotIn(List<String> values) {
            addCriterion("whether_suspend not in", values, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendBetween(String value1, String value2) {
            addCriterion("whether_suspend between", value1, value2, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andWhetherSuspendNotBetween(String value1, String value2) {
            addCriterion("whether_suspend not between", value1, value2, "whetherSuspend");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIsNull() {
            addCriterion("royalty_status is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIsNotNull() {
            addCriterion("royalty_status is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusEqualTo(String value) {
            addCriterion("royalty_status =", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotEqualTo(String value) {
            addCriterion("royalty_status <>", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusGreaterThan(String value) {
            addCriterion("royalty_status >", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusGreaterThanOrEqualTo(String value) {
            addCriterion("royalty_status >=", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusLessThan(String value) {
            addCriterion("royalty_status <", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusLessThanOrEqualTo(String value) {
            addCriterion("royalty_status <=", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusLike(String value) {
            addCriterion("royalty_status like", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotLike(String value) {
            addCriterion("royalty_status not like", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIn(List<String> values) {
            addCriterion("royalty_status in", values, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotIn(List<String> values) {
            addCriterion("royalty_status not in", values, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusBetween(String value1, String value2) {
            addCriterion("royalty_status between", value1, value2, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotBetween(String value1, String value2) {
            addCriterion("royalty_status not between", value1, value2, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIsNull() {
            addCriterion("royalty_money is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIsNotNull() {
            addCriterion("royalty_money is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyEqualTo(BigDecimal value) {
            addCriterion("royalty_money =", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotEqualTo(BigDecimal value) {
            addCriterion("royalty_money <>", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyGreaterThan(BigDecimal value) {
            addCriterion("royalty_money >", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("royalty_money >=", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyLessThan(BigDecimal value) {
            addCriterion("royalty_money <", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("royalty_money <=", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIn(List<BigDecimal> values) {
            addCriterion("royalty_money in", values, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotIn(List<BigDecimal> values) {
            addCriterion("royalty_money not in", values, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("royalty_money between", value1, value2, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("royalty_money not between", value1, value2, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmIsNull() {
            addCriterion("order_complete_tm is null");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmIsNotNull() {
            addCriterion("order_complete_tm is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmEqualTo(Date value) {
            addCriterion("order_complete_tm =", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmNotEqualTo(Date value) {
            addCriterion("order_complete_tm <>", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmGreaterThan(Date value) {
            addCriterion("order_complete_tm >", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmGreaterThanOrEqualTo(Date value) {
            addCriterion("order_complete_tm >=", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmLessThan(Date value) {
            addCriterion("order_complete_tm <", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmLessThanOrEqualTo(Date value) {
            addCriterion("order_complete_tm <=", value, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmIn(List<Date> values) {
            addCriterion("order_complete_tm in", values, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmNotIn(List<Date> values) {
            addCriterion("order_complete_tm not in", values, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmBetween(Date value1, Date value2) {
            addCriterion("order_complete_tm between", value1, value2, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andOrderCompleteTmNotBetween(Date value1, Date value2) {
            addCriterion("order_complete_tm not between", value1, value2, "orderCompleteTm");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdIsNull() {
            addCriterion("affiliation_company_id is null");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdIsNotNull() {
            addCriterion("affiliation_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdEqualTo(String value) {
            addCriterion("affiliation_company_id =", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdNotEqualTo(String value) {
            addCriterion("affiliation_company_id <>", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdGreaterThan(String value) {
            addCriterion("affiliation_company_id >", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("affiliation_company_id >=", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdLessThan(String value) {
            addCriterion("affiliation_company_id <", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("affiliation_company_id <=", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdLike(String value) {
            addCriterion("affiliation_company_id like", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdNotLike(String value) {
            addCriterion("affiliation_company_id not like", value, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdIn(List<String> values) {
            addCriterion("affiliation_company_id in", values, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdNotIn(List<String> values) {
            addCriterion("affiliation_company_id not in", values, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdBetween(String value1, String value2) {
            addCriterion("affiliation_company_id between", value1, value2, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andAffiliationCompanyIdNotBetween(String value1, String value2) {
            addCriterion("affiliation_company_id not between", value1, value2, "affiliationCompanyId");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(String value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNull() {
            addCriterion("contract_id is null");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNotNull() {
            addCriterion("contract_id is not null");
            return (Criteria) this;
        }

        public Criteria andContractIdEqualTo(String value) {
            addCriterion("contract_id =", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotEqualTo(String value) {
            addCriterion("contract_id <>", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThan(String value) {
            addCriterion("contract_id >", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThanOrEqualTo(String value) {
            addCriterion("contract_id >=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThan(String value) {
            addCriterion("contract_id <", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThanOrEqualTo(String value) {
            addCriterion("contract_id <=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLike(String value) {
            addCriterion("contract_id like", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotLike(String value) {
            addCriterion("contract_id not like", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdIn(List<String> values) {
            addCriterion("contract_id in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotIn(List<String> values) {
            addCriterion("contract_id not in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdBetween(String value1, String value2) {
            addCriterion("contract_id between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotBetween(String value1, String value2) {
            addCriterion("contract_id not between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andOldOrderIsNull() {
            addCriterion("old_order is null");
            return (Criteria) this;
        }

        public Criteria andOldOrderIsNotNull() {
            addCriterion("old_order is not null");
            return (Criteria) this;
        }

        public Criteria andOldOrderEqualTo(String value) {
            addCriterion("old_order =", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderNotEqualTo(String value) {
            addCriterion("old_order <>", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderGreaterThan(String value) {
            addCriterion("old_order >", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderGreaterThanOrEqualTo(String value) {
            addCriterion("old_order >=", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderLessThan(String value) {
            addCriterion("old_order <", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderLessThanOrEqualTo(String value) {
            addCriterion("old_order <=", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderLike(String value) {
            addCriterion("old_order like", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderNotLike(String value) {
            addCriterion("old_order not like", value, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderIn(List<String> values) {
            addCriterion("old_order in", values, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderNotIn(List<String> values) {
            addCriterion("old_order not in", values, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderBetween(String value1, String value2) {
            addCriterion("old_order between", value1, value2, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andOldOrderNotBetween(String value1, String value2) {
            addCriterion("old_order not between", value1, value2, "oldOrder");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataIsNull() {
            addCriterion("import_error_data is null");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataIsNotNull() {
            addCriterion("import_error_data is not null");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataEqualTo(String value) {
            addCriterion("import_error_data =", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataNotEqualTo(String value) {
            addCriterion("import_error_data <>", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataGreaterThan(String value) {
            addCriterion("import_error_data >", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataGreaterThanOrEqualTo(String value) {
            addCriterion("import_error_data >=", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataLessThan(String value) {
            addCriterion("import_error_data <", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataLessThanOrEqualTo(String value) {
            addCriterion("import_error_data <=", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataLike(String value) {
            addCriterion("import_error_data like", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataNotLike(String value) {
            addCriterion("import_error_data not like", value, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataIn(List<String> values) {
            addCriterion("import_error_data in", values, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataNotIn(List<String> values) {
            addCriterion("import_error_data not in", values, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataBetween(String value1, String value2) {
            addCriterion("import_error_data between", value1, value2, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andImportErrorDataNotBetween(String value1, String value2) {
            addCriterion("import_error_data not between", value1, value2, "importErrorData");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeIsNull() {
            addCriterion("online_order_type is null");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeIsNotNull() {
            addCriterion("online_order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeEqualTo(String value) {
            addCriterion("online_order_type =", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeNotEqualTo(String value) {
            addCriterion("online_order_type <>", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeGreaterThan(String value) {
            addCriterion("online_order_type >", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("online_order_type >=", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeLessThan(String value) {
            addCriterion("online_order_type <", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("online_order_type <=", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeLike(String value) {
            addCriterion("online_order_type like", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeNotLike(String value) {
            addCriterion("online_order_type not like", value, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeIn(List<String> values) {
            addCriterion("online_order_type in", values, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeNotIn(List<String> values) {
            addCriterion("online_order_type not in", values, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeBetween(String value1, String value2) {
            addCriterion("online_order_type between", value1, value2, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andOnlineOrderTypeNotBetween(String value1, String value2) {
            addCriterion("online_order_type not between", value1, value2, "onlineOrderType");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusIsNull() {
            addCriterion("exchange_code_sending_status is null");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusIsNotNull() {
            addCriterion("exchange_code_sending_status is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusEqualTo(Integer value) {
            addCriterion("exchange_code_sending_status =", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusNotEqualTo(Integer value) {
            addCriterion("exchange_code_sending_status <>", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusGreaterThan(Integer value) {
            addCriterion("exchange_code_sending_status >", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("exchange_code_sending_status >=", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusLessThan(Integer value) {
            addCriterion("exchange_code_sending_status <", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusLessThanOrEqualTo(Integer value) {
            addCriterion("exchange_code_sending_status <=", value, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusIn(List<Integer> values) {
            addCriterion("exchange_code_sending_status in", values, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusNotIn(List<Integer> values) {
            addCriterion("exchange_code_sending_status not in", values, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusBetween(Integer value1, Integer value2) {
            addCriterion("exchange_code_sending_status between", value1, value2, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeCodeSendingStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("exchange_code_sending_status not between", value1, value2, "exchangeCodeSendingStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNull() {
            addCriterion("refund_status is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("refund_status is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(Integer value) {
            addCriterion("refund_status =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(Integer value) {
            addCriterion("refund_status <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(Integer value) {
            addCriterion("refund_status >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("refund_status >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(Integer value) {
            addCriterion("refund_status <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(Integer value) {
            addCriterion("refund_status <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<Integer> values) {
            addCriterion("refund_status in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<Integer> values) {
            addCriterion("refund_status not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(Integer value1, Integer value2) {
            addCriterion("refund_status between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("refund_status not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIsNull() {
            addCriterion("maintain_status is null");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIsNotNull() {
            addCriterion("maintain_status is not null");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusEqualTo(Integer value) {
            addCriterion("maintain_status =", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotEqualTo(Integer value) {
            addCriterion("maintain_status <>", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusGreaterThan(Integer value) {
            addCriterion("maintain_status >", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("maintain_status >=", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusLessThan(Integer value) {
            addCriterion("maintain_status <", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusLessThanOrEqualTo(Integer value) {
            addCriterion("maintain_status <=", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIn(List<Integer> values) {
            addCriterion("maintain_status in", values, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotIn(List<Integer> values) {
            addCriterion("maintain_status not in", values, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusBetween(Integer value1, Integer value2) {
            addCriterion("maintain_status between", value1, value2, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("maintain_status not between", value1, value2, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeIsNull() {
            addCriterion("contract_other_type is null");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeIsNotNull() {
            addCriterion("contract_other_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeEqualTo(String value) {
            addCriterion("contract_other_type =", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeNotEqualTo(String value) {
            addCriterion("contract_other_type <>", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeGreaterThan(String value) {
            addCriterion("contract_other_type >", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_other_type >=", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeLessThan(String value) {
            addCriterion("contract_other_type <", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_other_type <=", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeLike(String value) {
            addCriterion("contract_other_type like", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeNotLike(String value) {
            addCriterion("contract_other_type not like", value, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeIn(List<String> values) {
            addCriterion("contract_other_type in", values, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeNotIn(List<String> values) {
            addCriterion("contract_other_type not in", values, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeBetween(String value1, String value2) {
            addCriterion("contract_other_type between", value1, value2, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andContractOtherTypeNotBetween(String value1, String value2) {
            addCriterion("contract_other_type not between", value1, value2, "contractOtherType");
            return (Criteria) this;
        }

        public Criteria andExamineStateIsNull() {
            addCriterion("examine_state is null");
            return (Criteria) this;
        }

        public Criteria andExamineStateIsNotNull() {
            addCriterion("examine_state is not null");
            return (Criteria) this;
        }

        public Criteria andExamineStateEqualTo(Short value) {
            addCriterion("examine_state =", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateNotEqualTo(Short value) {
            addCriterion("examine_state <>", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateGreaterThan(Short value) {
            addCriterion("examine_state >", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateGreaterThanOrEqualTo(Short value) {
            addCriterion("examine_state >=", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateLessThan(Short value) {
            addCriterion("examine_state <", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateLessThanOrEqualTo(Short value) {
            addCriterion("examine_state <=", value, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateIn(List<Short> values) {
            addCriterion("examine_state in", values, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateNotIn(List<Short> values) {
            addCriterion("examine_state not in", values, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateBetween(Short value1, Short value2) {
            addCriterion("examine_state between", value1, value2, "examineState");
            return (Criteria) this;
        }

        public Criteria andExamineStateNotBetween(Short value1, Short value2) {
            addCriterion("examine_state not between", value1, value2, "examineState");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}